Dataset statistics
| Number of variables | 22 |
|---|---|
| Number of observations | 36283 |
| Missing cells | 189199 |
| Missing cells (%) | 23.7% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 6.2 MiB |
| Average record size in memory | 179.2 B |
Variable types
| NUM | 15 |
|---|---|
| CAT | 7 |
Reproduction
| Analysis started | 2020-08-14 06:57:55.414171 |
|---|---|
| Analysis finished | 2020-08-14 06:58:45.629136 |
| Duration | 50.21 seconds |
| Software version | pandas-profiling v2.9.0rc1 |
| Download configuration | config.yaml |
name has a high cardinality: 35140 distinct values | High cardinality |
neighbourhood has a high cardinality: 61 distinct values | High cardinality |
zipcode has a high cardinality: 695 distinct values | High cardinality |
amenities has a high cardinality: 28222 distinct values | High cardinality |
monthly_price is highly correlated with weekly_price | High correlation |
weekly_price is highly correlated with monthly_price | High correlation |
neighbourhood has 13370 (36.8%) missing values | Missing |
zipcode has 20158 (55.6%) missing values | Missing |
beds has 380 (1.0%) missing values | Missing |
square_feet has 36269 (> 99.9%) missing values | Missing |
weekly_price has 35975 (99.2%) missing values | Missing |
monthly_price has 35967 (99.1%) missing values | Missing |
security_deposit has 23793 (65.6%) missing values | Missing |
cleaning_fee has 23123 (63.7%) missing values | Missing |
price is highly skewed (γ1 = 21.9409) | Skewed |
cleaning_fee is highly skewed (γ1 = 20.1208) | Skewed |
minimum_nights is highly skewed (γ1 = 22.4918) | Skewed |
maximum_nights is highly skewed (γ1 = 190.481) | Skewed |
name is uniformly distributed | Uniform |
id has unique values | Unique |
beds has 630 (1.7%) zeros | Zeros |
security_deposit has 4281 (11.8%) zeros | Zeros |
cleaning_fee has 4361 (12.0%) zeros | Zeros |
extra_people has 29249 (80.6%) zeros | Zeros |
| Distinct count | 36283 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.27986e+07 |
|---|---|
| Minimum | 44054 |
| Maximum | 4.3837e+07 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 283.5 KiB |
Quantile statistics
| Minimum | 44054 |
|---|---|
| 5-th percentile | 1.64859e+07 |
| Q1 | 2.81454e+07 |
| median | 3.48567e+07 |
| Q3 | 3.90941e+07 |
| 95-th percentile | 4.16701e+07 |
| Maximum | 4.3837e+07 |
| Range | 4.37929e+07 |
| Interquartile range (IQR) | 1.09487e+07 |
Descriptive statistics
| Standard deviation | 8.14257e+06 |
|---|---|
| Coefficient of variation (CV) | 0.24826 |
| Kurtosis | 0.825724 |
| Mean | 3.27986e+07 |
| Median Absolute Deviation (MAD) | 4.97636e+06 |
| Skewness | -1.09262 |
| Sum | 1.19003e+12 |
| Variance | 6.63015e+13 |
| Monotocity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 3.80846e+07 | 1 | < 0.1% | |
| 2.97546e+07 | 1 | < 0.1% | |
| 3.43805e+07 | 1 | < 0.1% | |
| 4.03612e+07 | 1 | < 0.1% | |
| 3.97919e+07 | 1 | < 0.1% | |
| 3.45531e+07 | 1 | < 0.1% | |
| 3.67793e+07 | 1 | < 0.1% | |
| 3.80142e+07 | 1 | < 0.1% | |
| 3.57246e+07 | 1 | < 0.1% | |
| 1.99161e+07 | 1 | < 0.1% | |
| Other values (36273) | 36273 | > 99.9% |
| Value | Count | Frequency (%) | |
| 44054 | 1 | < 0.1% | |
| 100213 | 1 | < 0.1% | |
| 114384 | 1 | < 0.1% | |
| 114465 | 1 | < 0.1% | |
| 128496 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 4.3837e+07 | 1 | < 0.1% | |
| 4.38368e+07 | 1 | < 0.1% | |
| 4.38367e+07 | 1 | < 0.1% | |
| 4.38366e+07 | 1 | < 0.1% | |
| 4.38365e+07 | 1 | < 0.1% |
| Distinct count | 35140 |
|---|---|
| Unique (%) | 96.9% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 283.5 KiB |
| 嘉度resort丨近慕田峪长城､红螺寺､圣泉寺､响水湖丨房屋空间开阔,是家庭出游及公司团建不二之选 | 33 |
|---|---|
| 中关村颐和园北京大学新东方地铁直达 | 22 |
| 豪华特大号床间,整套45㎡｡首都机场T3､新国展､黑骑士､松美术馆､国家会计学院｡免费接送机､早餐｡ | 18 |
| 心归宿瀚洋店-【林间小屋】独栋木屋大床房､距市区11公里､密云水库､白龙潭､平谷桃花海､垂钓 | 17 |
| 温馨小屋 | 17 |
| Other values (35135) |
| Value | Count | Frequency (%) | |
| 嘉度resort丨近慕田峪长城､红螺寺､圣泉寺､响水湖丨房屋空间开阔,是家庭出游及公司团建不二之选 | 33 | 0.1% | |
| 中关村颐和园北京大学新东方地铁直达 | 22 | 0.1% | |
| 豪华特大号床间,整套45㎡｡首都机场T3､新国展､黑骑士､松美术馆､国家会计学院｡免费接送机､早餐｡ | 18 | < 0.1% | |
| 心归宿瀚洋店-【林间小屋】独栋木屋大床房､距市区11公里､密云水库､白龙潭､平谷桃花海､垂钓 | 17 | < 0.1% | |
| 温馨小屋 | 17 | < 0.1% | |
| 三居可随时长租1.2万◆北海北地铁口胡同大平房,北大医院､恭王府､后海､北海､南锣鼓巷､簋街､三里屯 | 15 | < 0.1% | |
| 朝阳,四惠,高碑店,百子湾,传媒大学,第二外国语学院,东五环,超级蜂巢,房间清新整洁舒适大床房｡ | 14 | < 0.1% | |
| 中关村新东方清华大学北京大学颐和园人民大学中湾国际 | 11 | < 0.1% | |
| 延庆绿茵溪谷古堡 双人标间 紧邻神庙峰 双龙潭 绿荫山泉 欢迎品尝特色农家菜 | 10 | < 0.1% | |
| 距离北京西站15分钟的幸福村民宿 | 10 | < 0.1% | |
| Other values (35130) | 36115 | 99.5% |
Length
| Max length | 127 |
|---|---|
| Median length | 27 |
| Mean length | 28.3088 |
| Min length | 1 |
| Distinct count | 61 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 13370 |
| Missing (%) | 36.8% |
| Memory size | 38.4 KiB |
| Chaoyang | |
|---|---|
| Dongcheng | |
| Fengtai | |
| Haidian | |
| Xicheng | |
| Other values (56) |
| Value | Count | Frequency (%) | |
| Chaoyang | 6949 | 19.2% | |
| Dongcheng | 2039 | 5.6% | |
| Fengtai | 1839 | 5.1% | |
| Haidian | 1755 | 4.8% | |
| Xicheng | 1177 | 3.2% | |
| Sanlitun | 704 | 1.9% | |
| Jinsong/Panjiayuan | 575 | 1.6% | |
| Wangjing | 432 | 1.2% | |
| Shilipu | 421 | 1.2% | |
| Chongwenmen | 397 | 1.1% | |
| Other values (51) | 6625 | 18.3% | |
| (Missing) | 13370 | 36.8% |
Length
| Max length | 36 |
|---|---|
| Median length | 7 |
| Mean length | 6.85078 |
| Min length | 3 |
neighbourhood_cleansed
Categorical
| Distinct count | 16 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 36.2 KiB |
| 朝阳区 / Chaoyang | |
|---|---|
| 东城区 | |
| 海淀区 | |
| 丰台区 / Fengtai | |
| 延庆县 / Yanqing | |
| Other values (11) |
| Value | Count | Frequency (%) | |
| 朝阳区 / Chaoyang | 11583 | 31.9% | |
| 东城区 | 3656 | 10.1% | |
| 海淀区 | 3209 | 8.8% | |
| 丰台区 / Fengtai | 2434 | 6.7% | |
| 延庆县 / Yanqing | 2217 | 6.1% | |
| 密云县 / Miyun | 1919 | 5.3% | |
| 西城区 | 1871 | 5.2% | |
| 通州区 / Tongzhou | 1632 | 4.5% | |
| 怀柔区 / Huairou | 1617 | 4.5% | |
| 昌平区 | 1576 | 4.3% | |
| Other values (6) | 4569 | 12.6% |
Length
| Max length | 16 |
|---|---|
| Median length | 13 |
| Mean length | 10.0023 |
| Min length | 3 |
| Distinct count | 695 |
|---|---|
| Unique (%) | 4.3% |
| Missing | 20158 |
| Missing (%) | 55.6% |
| Memory size | 96.3 KiB |
| 100000 | 1123 |
|---|---|
| 100001 | 777 |
| 100096 | 759 |
| 100000 | 739 |
| 38294 | 676 |
| Other values (690) |
| Value | Count | Frequency (%) | |
| 100000 | 1123 | 3.1% | |
| 100001 | 777 | 2.1% | |
| 100096 | 759 | 2.1% | |
| 100000 | 739 | 2.0% | |
| 38294 | 676 | 1.9% | |
| 100022 | 543 | 1.5% | |
| 100009 | 422 | 1.2% | |
| 100025 | 334 | 0.9% | |
| 101505 | 306 | 0.8% | |
| 100176 | 272 | 0.7% | |
| Other values (685) | 10174 | 28.0% | |
| (Missing) | 20158 | 55.6% |
Length
| Max length | 10 |
|---|---|
| Median length | 3 |
| Mean length | 4.5981 |
| Min length | 1 |
property_type
Categorical
| Distinct count | 45 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 37.0 KiB |
| Apartment | |
|---|---|
| Condominium | |
| House | |
| Loft | |
| Serviced apartment | |
| Other values (40) |
| Value | Count | Frequency (%) | |
| Apartment | 14428 | 39.8% | |
| Condominium | 4761 | 13.1% | |
| House | 4129 | 11.4% | |
| Loft | 2960 | 8.2% | |
| Serviced apartment | 2189 | 6.0% | |
| Farm stay | 1330 | 3.7% | |
| Villa | 1222 | 3.4% | |
| Bungalow | 985 | 2.7% | |
| Cottage | 596 | 1.6% | |
| Townhouse | 513 | 1.4% | |
| Other values (35) | 3170 | 8.7% |
Length
| Max length | 22 |
|---|---|
| Median length | 9 |
| Mean length | 8.87807 |
| Min length | 3 |
room_type
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 35.5 KiB |
| Entire home/apt | |
|---|---|
| Private room | |
| Shared room | 1667 |
| Value | Count | Frequency (%) | |
| Entire home/apt | 22172 | 61.1% | |
| Private room | 12444 | 34.3% | |
| Shared room | 1667 | 4.6% |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 13.7873 |
| Min length | 11 |
accommodates
Real number (ℝ≥0)
| Distinct count | 17 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.74211 |
|---|---|
| Minimum | 1 |
| Maximum | 18 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 283.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 10 |
| Maximum | 18 |
| Range | 17 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 3.0897 |
|---|---|
| Coefficient of variation (CV) | 0.825656 |
| Kurtosis | 5.70825 |
| Mean | 3.74211 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.33703 |
| Sum | 135775 |
| Variance | 9.54622 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=17)
| Value | Count | Frequency (%) | |
| 2 | 16301 | 44.9% | |
| 4 | 6506 | 17.9% | |
| 3 | 3001 | 8.3% | |
| 1 | 2743 | 7.6% | |
| 6 | 2347 | 6.5% | |
| 5 | 1354 | 3.7% | |
| 8 | 949 | 2.6% | |
| 16 | 906 | 2.5% | |
| 10 | 627 | 1.7% | |
| 7 | 487 | 1.3% | |
| Other values (7) | 1062 | 2.9% |
| Value | Count | Frequency (%) | |
| 1 | 2743 | 7.6% | |
| 2 | 16301 | 44.9% | |
| 3 | 3001 | 8.3% | |
| 4 | 6506 | 17.9% | |
| 5 | 1354 | 3.7% |
| Value | Count | Frequency (%) | |
| 18 | 1 | < 0.1% | |
| 16 | 906 | 2.5% | |
| 15 | 131 | 0.4% | |
| 14 | 147 | 0.4% | |
| 13 | 83 | 0.2% |
bathrooms
Real number (ℝ≥0)
| Distinct count | 43 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 21 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.42426 |
|---|---|
| Minimum | 0 |
| Maximum | 101.5 |
| Zeros | 170 |
| Zeros (%) | 0.5% |
| Memory size | 283.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1.5 |
| 95-th percentile | 3 |
| Maximum | 101.5 |
| Range | 101.5 |
| Interquartile range (IQR) | 0.5 |
Descriptive statistics
| Standard deviation | 1.37529 |
|---|---|
| Coefficient of variation (CV) | 0.96562 |
| Kurtosis | 1038.81 |
| Mean | 1.42426 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 19.0739 |
| Sum | 51646.5 |
| Variance | 1.89143 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=43)
| Value | Count | Frequency (%) | |
| 1 | 25075 | 69.1% | |
| 1.5 | 4530 | 12.5% | |
| 2 | 3206 | 8.8% | |
| 3 | 841 | 2.3% | |
| 0.5 | 518 | 1.4% | |
| 4 | 471 | 1.3% | |
| 2.5 | 275 | 0.8% | |
| 5 | 264 | 0.7% | |
| 6 | 201 | 0.6% | |
| 0 | 170 | 0.5% | |
| Other values (33) | 711 | 2.0% |
| Value | Count | Frequency (%) | |
| 0 | 170 | 0.5% | |
| 0.5 | 518 | 1.4% | |
| 1 | 25075 | 69.1% | |
| 1.5 | 4530 | 12.5% | |
| 2 | 3206 | 8.8% |
| Value | Count | Frequency (%) | |
| 101.5 | 1 | < 0.1% | |
| 75 | 1 | < 0.1% | |
| 33 | 1 | < 0.1% | |
| 31 | 1 | < 0.1% | |
| 25 | 2 | < 0.1% |
bedrooms
Real number (ℝ≥0)
| Distinct count | 26 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 142 |
| Missing (%) | 0.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.66307 |
|---|---|
| Minimum | 0 |
| Maximum | 50 |
| Zeros | 140 |
| Zeros (%) | 0.4% |
| Memory size | 283.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 50 |
| Range | 50 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.48003 |
|---|---|
| Coefficient of variation (CV) | 0.889938 |
| Kurtosis | 90.4273 |
| Mean | 1.66307 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.79604 |
| Sum | 60105 |
| Variance | 2.19049 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=26)
| Value | Count | Frequency (%) | |
| 1 | 24234 | 66.8% | |
| 2 | 6783 | 18.7% | |
| 3 | 2343 | 6.5% | |
| 4 | 985 | 2.7% | |
| 5 | 589 | 1.6% | |
| 6 | 407 | 1.1% | |
| 7 | 225 | 0.6% | |
| 8 | 142 | 0.4% | |
| 0 | 140 | 0.4% | |
| 10 | 132 | 0.4% | |
| Other values (16) | 161 | 0.4% | |
| (Missing) | 142 | 0.4% |
| Value | Count | Frequency (%) | |
| 0 | 140 | 0.4% | |
| 1 | 24234 | 66.8% | |
| 2 | 6783 | 18.7% | |
| 3 | 2343 | 6.5% | |
| 4 | 985 | 2.7% |
| Value | Count | Frequency (%) | |
| 50 | 2 | < 0.1% | |
| 31 | 1 | < 0.1% | |
| 25 | 2 | < 0.1% | |
| 24 | 1 | < 0.1% | |
| 23 | 2 | < 0.1% |
| Distinct count | 46 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 380 |
| Missing (%) | 1.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.24226 |
|---|---|
| Minimum | 0 |
| Maximum | 115 |
| Zeros | 630 |
| Zeros (%) | 1.7% |
| Memory size | 283.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 6 |
| Maximum | 115 |
| Range | 115 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 2.75371 |
|---|---|
| Coefficient of variation (CV) | 1.2281 |
| Kurtosis | 138.979 |
| Mean | 2.24226 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 7.72516 |
| Sum | 80504 |
| Variance | 7.58294 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=46)
| Value | Count | Frequency (%) | |
| 1 | 17372 | 47.9% | |
| 2 | 9639 | 26.6% | |
| 3 | 3537 | 9.7% | |
| 4 | 1840 | 5.1% | |
| 5 | 772 | 2.1% | |
| 0 | 630 | 1.7% | |
| 6 | 544 | 1.5% | |
| 8 | 304 | 0.8% | |
| 7 | 267 | 0.7% | |
| 16 | 167 | 0.5% | |
| Other values (36) | 831 | 2.3% | |
| (Missing) | 380 | 1.0% |
| Value | Count | Frequency (%) | |
| 0 | 630 | 1.7% | |
| 1 | 17372 | 47.9% | |
| 2 | 9639 | 26.6% | |
| 3 | 3537 | 9.7% | |
| 4 | 1840 | 5.1% |
| Value | Count | Frequency (%) | |
| 115 | 1 | < 0.1% | |
| 70 | 1 | < 0.1% | |
| 50 | 3 | < 0.1% | |
| 47 | 1 | < 0.1% | |
| 45 | 7 | < 0.1% |
| Distinct count | 28222 |
|---|---|
| Unique (%) | 77.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| {} | 82 |
|---|---|
| {TV,Wifi,"Air conditioning",Kitchen,"Smoking allowed",Elevator,Heating,Washer,"Smoke alarm","Carbon monoxide alarm","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer","Laptop-friendly workspace","Private entrance"} | 77 |
| {TV,Wifi,"Smoking allowed","Pets allowed","Family/kid friendly","Suitable for events",Washer,"Fire extinguisher",Essentials,Shampoo,"Hair dryer","Laptop-friendly workspace"} | 71 |
| {TV,Wifi,"Air conditioning",Kitchen,"Smoking allowed","Pets allowed",Elevator,Heating,Washer,"Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer","Private entrance"} | 67 |
| {TV,Wifi,"Air conditioning",Elevator,Heating,Essentials,Shampoo,Hangers,"Hair dryer","Laptop-friendly workspace","Private entrance"} | 53 |
| Other values (28217) |
| Value | Count | Frequency (%) | |
| {} | 82 | 0.2% | |
| {TV,Wifi,"Air conditioning",Kitchen,"Smoking allowed",Elevator,Heating,Washer,"Smoke alarm","Carbon monoxide alarm","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer","Laptop-friendly workspace","Private entrance"} | 77 | 0.2% | |
| {TV,Wifi,"Smoking allowed","Pets allowed","Family/kid friendly","Suitable for events",Washer,"Fire extinguisher",Essentials,Shampoo,"Hair dryer","Laptop-friendly workspace"} | 71 | 0.2% | |
| {TV,Wifi,"Air conditioning",Kitchen,"Smoking allowed","Pets allowed",Elevator,Heating,Washer,"Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer","Private entrance"} | 67 | 0.2% | |
| {TV,Wifi,"Air conditioning",Elevator,Heating,Essentials,Shampoo,Hangers,"Hair dryer","Laptop-friendly workspace","Private entrance"} | 53 | 0.1% | |
| {TV,Wifi,"Air conditioning",Kitchen,Elevator,Heating,Washer,Essentials,Shampoo,Hangers,"Hair dryer","Laptop-friendly workspace","Hot water"} | 47 | 0.1% | |
| {TV,Wifi,"Air conditioning",Kitchen,Elevator,Heating,Washer,"Smoke alarm",Essentials,Shampoo,Hangers,"Hair dryer","Laptop-friendly workspace","Hot water"} | 41 | 0.1% | |
| {TV,Wifi,"Air conditioning",Kitchen,Elevator,Heating,Washer,Essentials,Shampoo,Hangers,"Hair dryer","Hot water"} | 41 | 0.1% | |
| {Wifi,"Air conditioning",Kitchen,Gym,Elevator,Heating,"Suitable for events",Washer,"Smoke alarm","First aid kit","Fire extinguisher",Hangers,"Laptop-friendly workspace","Hot water"} | 40 | 0.1% | |
| {Wifi,"Air conditioning",Elevator,Heating,Washer,Essentials,Shampoo,"Lock on bedroom door","Hair dryer","Laptop-friendly workspace"} | 38 | 0.1% | |
| Other values (28212) | 35726 | 98.5% |
Length
| Max length | 1917 |
|---|---|
| Median length | 261 |
| Mean length | 305.847 |
| Min length | 2 |
| Distinct count | 9 |
|---|---|
| Unique (%) | 64.3% |
| Missing | 36269 |
| Missing (%) | > 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 607.571 |
|---|---|
| Minimum | 0 |
| Maximum | 4306 |
| Zeros | 5 |
| Zeros (%) | < 0.1% |
| Memory size | 283.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 215.5 |
| Q3 | 603 |
| 95-th percentile | 2458.7 |
| Maximum | 4306 |
| Range | 4306 |
| Interquartile range (IQR) | 603 |
Descriptive statistics
| Standard deviation | 1141.87 |
|---|---|
| Coefficient of variation (CV) | 1.8794 |
| Kurtosis | 9.72691 |
| Mean | 607.571 |
| Median Absolute Deviation (MAD) | 215.5 |
| Skewness | 2.99983 |
| Sum | 8506 |
| Variance | 1.30386e+06 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) | |
| 0 | 5 | < 0.1% | |
| 603 | 2 | < 0.1% | |
| 377 | 1 | < 0.1% | |
| 55 | 1 | < 0.1% | |
| 667 | 1 | < 0.1% | |
| 108 | 1 | < 0.1% | |
| 1464 | 1 | < 0.1% | |
| 4306 | 1 | < 0.1% | |
| 323 | 1 | < 0.1% | |
| (Missing) | 36269 | > 99.9% |
| Value | Count | Frequency (%) | |
| 0 | 5 | < 0.1% | |
| 55 | 1 | < 0.1% | |
| 108 | 1 | < 0.1% | |
| 323 | 1 | < 0.1% | |
| 377 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 4306 | 1 | < 0.1% | |
| 1464 | 1 | < 0.1% | |
| 667 | 1 | < 0.1% | |
| 603 | 2 | < 0.1% | |
| 377 | 1 | < 0.1% |
| Distinct count | 1007 |
|---|---|
| Unique (%) | 2.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 726.046 |
|---|---|
| Minimum | 0 |
| Maximum | 70723 |
| Zeros | 12 |
| Zeros (%) | < 0.1% |
| Memory size | 283.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 120 |
| Q1 | 255 |
| median | 396 |
| Q3 | 651 |
| 95-th percentile | 2300 |
| Maximum | 70723 |
| Range | 70723 |
| Interquartile range (IQR) | 396 |
Descriptive statistics
| Standard deviation | 1861.04 |
|---|---|
| Coefficient of variation (CV) | 2.56325 |
| Kurtosis | 695.601 |
| Mean | 726.046 |
| Median Absolute Deviation (MAD) | 177 |
| Skewness | 21.9409 |
| Sum | 2.63431e+07 |
| Variance | 3.46347e+06 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 297 | 1370 | 3.8% | |
| 198 | 1135 | 3.1% | |
| 396 | 1095 | 3.0% | |
| 269 | 756 | 2.1% | |
| 290 | 701 | 1.9% | |
| 368 | 662 | 1.8% | |
| 361 | 614 | 1.7% | |
| 389 | 579 | 1.6% | |
| 149 | 548 | 1.5% | |
| 99 | 510 | 1.4% | |
| Other values (997) | 28313 | 78.0% |
| Value | Count | Frequency (%) | |
| 0 | 12 | < 0.1% | |
| 28 | 1 | < 0.1% | |
| 42 | 1 | < 0.1% | |
| 57 | 3 | < 0.1% | |
| 64 | 30 | 0.1% |
| Value | Count | Frequency (%) | |
| 70723 | 1 | < 0.1% | |
| 70656 | 1 | < 0.1% | |
| 70002 | 1 | < 0.1% | |
| 69599 | 1 | < 0.1% | |
| 68997 | 1 | < 0.1% |
| Distinct count | 191 |
|---|---|
| Unique (%) | 62.0% |
| Missing | 35975 |
| Missing (%) | 99.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2771.67 |
|---|---|
| Minimum | 150 |
| Maximum | 42000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 283.5 KiB |
Quantile statistics
| Minimum | 150 |
|---|---|
| 5-th percentile | 485 |
| Q1 | 1000 |
| median | 1765 |
| Q3 | 3000 |
| 95-th percentile | 7974.45 |
| Maximum | 42000 |
| Range | 41850 |
| Interquartile range (IQR) | 2000 |
Descriptive statistics
| Standard deviation | 3859.29 |
|---|---|
| Coefficient of variation (CV) | 1.39241 |
| Kurtosis | 44.3421 |
| Mean | 2771.67 |
| Median Absolute Deviation (MAD) | 976 |
| Skewness | 5.69568 |
| Sum | 853673 |
| Variance | 1.48942e+07 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1000 | 9 | < 0.1% | |
| 3000 | 8 | < 0.1% | |
| 1600 | 8 | < 0.1% | |
| 1500 | 8 | < 0.1% | |
| 1200 | 8 | < 0.1% | |
| 800 | 7 | < 0.1% | |
| 2000 | 6 | < 0.1% | |
| 4000 | 5 | < 0.1% | |
| 485 | 5 | < 0.1% | |
| 560 | 5 | < 0.1% | |
| Other values (181) | 239 | 0.7% | |
| (Missing) | 35975 | 99.2% |
| Value | Count | Frequency (%) | |
| 150 | 1 | < 0.1% | |
| 160 | 1 | < 0.1% | |
| 240 | 1 | < 0.1% | |
| 255 | 1 | < 0.1% | |
| 280 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 42000 | 1 | < 0.1% | |
| 27249 | 1 | < 0.1% | |
| 24000 | 1 | < 0.1% | |
| 20156 | 1 | < 0.1% | |
| 18912 | 1 | < 0.1% |
| Distinct count | 185 |
|---|---|
| Unique (%) | 58.5% |
| Missing | 35967 |
| Missing (%) | 99.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10359.7 |
|---|---|
| Minimum | 400 |
| Maximum | 150000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 283.5 KiB |
Quantile statistics
| Minimum | 400 |
|---|---|
| 5-th percentile | 1600 |
| Q1 | 3275.75 |
| median | 6400 |
| Q3 | 12097.5 |
| 95-th percentile | 30000 |
| Maximum | 150000 |
| Range | 149600 |
| Interquartile range (IQR) | 8821.75 |
Descriptive statistics
| Standard deviation | 13553.9 |
|---|---|
| Coefficient of variation (CV) | 1.30833 |
| Kurtosis | 40.9218 |
| Mean | 10359.7 |
| Median Absolute Deviation (MAD) | 3800 |
| Skewness | 5.17697 |
| Sum | 3.27367e+06 |
| Variance | 1.83708e+08 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 6000 | 10 | < 0.1% | |
| 2100 | 8 | < 0.1% | |
| 4000 | 8 | < 0.1% | |
| 6500 | 7 | < 0.1% | |
| 18000 | 7 | < 0.1% | |
| 8000 | 6 | < 0.1% | |
| 2900 | 5 | < 0.1% | |
| 12000 | 5 | < 0.1% | |
| 3000 | 5 | < 0.1% | |
| 11000 | 5 | < 0.1% | |
| Other values (175) | 250 | 0.7% | |
| (Missing) | 35967 | 99.1% |
| Value | Count | Frequency (%) | |
| 400 | 1 | < 0.1% | |
| 530 | 1 | < 0.1% | |
| 600 | 1 | < 0.1% | |
| 625 | 1 | < 0.1% | |
| 824 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 150000 | 1 | < 0.1% | |
| 84932 | 1 | < 0.1% | |
| 78205 | 1 | < 0.1% | |
| 60000 | 3 | < 0.1% | |
| 50015 | 1 | < 0.1% |
| Distinct count | 301 |
|---|---|
| Unique (%) | 2.4% |
| Missing | 23793 |
| Missing (%) | 65.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 655.045 |
|---|---|
| Minimum | 0 |
| Maximum | 35362 |
| Zeros | 4281 |
| Zeros (%) | 11.8% |
| Memory size | 283.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 200 |
| Q3 | 700 |
| 95-th percentile | 2000 |
| Maximum | 35362 |
| Range | 35362 |
| Interquartile range (IQR) | 700 |
Descriptive statistics
| Standard deviation | 2337.31 |
|---|---|
| Coefficient of variation (CV) | 3.56816 |
| Kurtosis | 139.773 |
| Mean | 655.045 |
| Median Absolute Deviation (MAD) | 200 |
| Skewness | 11.0603 |
| Sum | 8.18151e+06 |
| Variance | 5.463e+06 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 4281 | 11.8% | |
| 200 | 1340 | 3.7% | |
| 500 | 1034 | 2.8% | |
| 1000 | 1007 | 2.8% | |
| 300 | 887 | 2.4% | |
| 700 | 630 | 1.7% | |
| 100 | 558 | 1.5% | |
| 800 | 526 | 1.4% | |
| 2000 | 272 | 0.7% | |
| 600 | 168 | 0.5% | |
| Other values (291) | 1787 | 4.9% | |
| (Missing) | 23793 | 65.6% |
| Value | Count | Frequency (%) | |
| 0 | 4281 | 11.8% | |
| 5 | 2 | < 0.1% | |
| 10 | 6 | < 0.1% | |
| 20 | 8 | < 0.1% | |
| 25 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 35362 | 1 | < 0.1% | |
| 35319 | 1 | < 0.1% | |
| 35000 | 3 | < 0.1% | |
| 34736 | 2 | < 0.1% | |
| 34343 | 2 | < 0.1% |
| Distinct count | 186 |
|---|---|
| Unique (%) | 1.4% |
| Missing | 23123 |
| Missing (%) | 63.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 60.9431 |
|---|---|
| Minimum | 0 |
| Maximum | 10000 |
| Zeros | 4361 |
| Zeros (%) | 12.0% |
| Memory size | 283.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 40 |
| Q3 | 70 |
| 95-th percentile | 150 |
| Maximum | 10000 |
| Range | 10000 |
| Interquartile range (IQR) | 70 |
Descriptive statistics
| Standard deviation | 218.669 |
|---|---|
| Coefficient of variation (CV) | 3.58808 |
| Kurtosis | 546.789 |
| Mean | 60.9431 |
| Median Absolute Deviation (MAD) | 40 |
| Skewness | 20.1208 |
| Sum | 802011 |
| Variance | 47816.1 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 4361 | 12.0% | |
| 50 | 1571 | 4.3% | |
| 100 | 730 | 2.0% | |
| 80 | 669 | 1.8% | |
| 60 | 648 | 1.8% | |
| 40 | 459 | 1.3% | |
| 35 | 446 | 1.2% | |
| 30 | 368 | 1.0% | |
| 70 | 295 | 0.8% | |
| 20 | 278 | 0.8% | |
| Other values (176) | 3335 | 9.2% | |
| (Missing) | 23123 | 63.7% |
| Value | Count | Frequency (%) | |
| 0 | 4361 | 12.0% | |
| 1 | 5 | < 0.1% | |
| 2 | 5 | < 0.1% | |
| 3 | 5 | < 0.1% | |
| 4 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 10000 | 1 | < 0.1% | |
| 4157 | 1 | < 0.1% | |
| 4138 | 2 | < 0.1% | |
| 4000 | 22 | 0.1% | |
| 3344 | 1 | < 0.1% |
guests_included
Real number (ℝ≥0)
| Distinct count | 16 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.36499 |
|---|---|
| Minimum | 1 |
| Maximum | 16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 283.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.25698 |
|---|---|
| Coefficient of variation (CV) | 0.920869 |
| Kurtosis | 47.1697 |
| Mean | 1.36499 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.89996 |
| Sum | 49526 |
| Variance | 1.58 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) | |
| 1 | 30873 | 85.1% | |
| 2 | 2886 | 8.0% | |
| 4 | 1176 | 3.2% | |
| 3 | 427 | 1.2% | |
| 6 | 348 | 1.0% | |
| 5 | 205 | 0.6% | |
| 8 | 121 | 0.3% | |
| 10 | 70 | 0.2% | |
| 16 | 55 | 0.2% | |
| 7 | 41 | 0.1% | |
| Other values (6) | 81 | 0.2% |
| Value | Count | Frequency (%) | |
| 1 | 30873 | 85.1% | |
| 2 | 2886 | 8.0% | |
| 3 | 427 | 1.2% | |
| 4 | 1176 | 3.2% | |
| 5 | 205 | 0.6% |
| Value | Count | Frequency (%) | |
| 16 | 55 | 0.2% | |
| 15 | 5 | < 0.1% | |
| 14 | 11 | < 0.1% | |
| 13 | 4 | < 0.1% | |
| 12 | 36 | 0.1% |
| Distinct count | 190 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.4737 |
|---|---|
| Minimum | 0 |
| Maximum | 2118 |
| Zeros | 29249 |
| Zeros (%) | 80.6% |
| Memory size | 283.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 100 |
| Maximum | 2118 |
| Range | 2118 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 79.1011 |
|---|---|
| Coefficient of variation (CV) | 3.86355 |
| Kurtosis | 302.14 |
| Mean | 20.4737 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 14.3015 |
| Sum | 742846 |
| Variance | 6256.98 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 29249 | 80.6% | |
| 50 | 1719 | 4.7% | |
| 100 | 1650 | 4.5% | |
| 80 | 576 | 1.6% | |
| 60 | 299 | 0.8% | |
| 200 | 291 | 0.8% | |
| 150 | 285 | 0.8% | |
| 35 | 214 | 0.6% | |
| 40 | 167 | 0.5% | |
| 30 | 123 | 0.3% | |
| Other values (180) | 1710 | 4.7% |
| Value | Count | Frequency (%) | |
| 0 | 29249 | 80.6% | |
| 1 | 4 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 8 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2118 | 1 | < 0.1% | |
| 2084 | 1 | < 0.1% | |
| 2064 | 1 | < 0.1% | |
| 2000 | 16 | < 0.1% | |
| 1995 | 2 | < 0.1% |
| Distinct count | 66 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.30758 |
|---|---|
| Minimum | 1 |
| Maximum | 1086 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 283.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 14 |
| Maximum | 1086 |
| Range | 1085 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 28.3065 |
|---|---|
| Coefficient of variation (CV) | 6.57133 |
| Kurtosis | 672.164 |
| Mean | 4.30758 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 22.4918 |
| Sum | 156292 |
| Variance | 801.26 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1 | 30216 | 83.3% | |
| 2 | 2178 | 6.0% | |
| 3 | 1024 | 2.8% | |
| 30 | 819 | 2.3% | |
| 7 | 369 | 1.0% | |
| 5 | 368 | 1.0% | |
| 15 | 316 | 0.9% | |
| 90 | 175 | 0.5% | |
| 10 | 161 | 0.4% | |
| 60 | 89 | 0.2% | |
| Other values (56) | 568 | 1.6% |
| Value | Count | Frequency (%) | |
| 1 | 30216 | 83.3% | |
| 2 | 2178 | 6.0% | |
| 3 | 1024 | 2.8% | |
| 4 | 79 | 0.2% | |
| 5 | 368 | 1.0% |
| Value | Count | Frequency (%) | |
| 1086 | 1 | < 0.1% | |
| 1000 | 6 | < 0.1% | |
| 999 | 7 | < 0.1% | |
| 600 | 2 | < 0.1% | |
| 500 | 1 | < 0.1% |
| Distinct count | 167 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28487.8 |
|---|---|
| Minimum | 1 |
| Maximum | 1e+09 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 283.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 30 |
| Q1 | 1125 |
| median | 1125 |
| Q3 | 1125 |
| 95-th percentile | 1125 |
| Maximum | 1e+09 |
| Range | 1e+09 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 5.24986e+06 |
|---|---|
| Coefficient of variation (CV) | 184.284 |
| Kurtosis | 36283 |
| Mean | 28487.8 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 190.481 |
| Sum | 1.03362e+09 |
| Variance | 2.75611e+13 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1125 | 28531 | 78.6% | |
| 365 | 1866 | 5.1% | |
| 30 | 1608 | 4.4% | |
| 90 | 578 | 1.6% | |
| 60 | 406 | 1.1% | |
| 7 | 384 | 1.1% | |
| 100 | 212 | 0.6% | |
| 31 | 194 | 0.5% | |
| 15 | 189 | 0.5% | |
| 180 | 187 | 0.5% | |
| Other values (157) | 2128 | 5.9% |
| Value | Count | Frequency (%) | |
| 1 | 48 | 0.1% | |
| 2 | 37 | 0.1% | |
| 3 | 78 | 0.2% | |
| 4 | 30 | 0.1% | |
| 5 | 130 | 0.4% |
| Value | Count | Frequency (%) | |
| 1e+09 | 1 | < 0.1% | |
| 50000 | 1 | < 0.1% | |
| 9999 | 1 | < 0.1% | |
| 1825 | 1 | < 0.1% | |
| 1460 | 1 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| id | name | neighbourhood | neighbourhood_cleansed | zipcode | property_type | room_type | accommodates | bathrooms | bedrooms | beds | amenities | square_feet | price | weekly_price | monthly_price | security_deposit | cleaning_fee | guests_included | extra_people | minimum_nights | maximum_nights | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 44054 | Modern and Comfortable Living in CBD | Chaoyang | 朝阳区 / Chaoyang | 100022 | Serviced apartment | Entire home/apt | 9 | 2.0 | 3.0 | 4.0 | {TV,"Cable TV",Internet,Wifi,"Air conditioning","Wheelchair accessible",Kitchen,"Pets allowed",Elevator,"Free street parking","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,"Smoke alarm","Carbon monoxide alarm","Safety card","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","Self check-in","Smart lock","Children’s books and toys",Crib,"Hot water","Luggage dropoff allowed","Long term stays allowed","Paid parking on premises"} | 1464.0 | 835.0 | 8373.0 | 27603.0 | 708.0 | 71.0 | 6 | 71.0 | 2 | 365 |
| 1 | 100213 | The Great Wall Box Deluxe Suite A团园长城小院东院套房 | NaN | 密云县 / Miyun | 101508 | Guest suite | Private room | 2 | 1.0 | 1.0 | 1.0 | {Internet,Wifi,"Air conditioning","Free parking on premises",Breakfast,"Pets live on this property",Cat(s),"Indoor fireplace",Heating,"Family/kid friendly",Washer,Dryer,Essentials,Shampoo,Hangers,"Hair dryer","Private living room","Private entrance","Bed linens","Extra pillows and blankets","Garden or backyard"} | NaN | 1203.0 | 7200.0 | 28800.0 | 0.0 | 0.0 | 1 | 0.0 | 1 | 30 |
| 2 | 114384 | CBD Luxury 1-bedroom suite with a 30m2 terrace | ITC | 朝阳区 / Chaoyang | NaN | Apartment | Entire home/apt | 2 | 1.0 | 1.0 | 1.0 | {TV,"Cable TV",Internet,Wifi,"Air conditioning",Kitchen,"Smoking allowed",Doorman,Elevator,Heating,"Family/kid friendly",Washer,"Smoke alarm","Carbon monoxide alarm","Fire extinguisher",Shampoo,Hangers,"Hair dryer","Laptop-friendly workspace","Hot water","Bed linens","Ethernet connection","Shower gel"} | NaN | 602.0 | 4200.0 | NaN | NaN | NaN | 1 | 0.0 | 1 | 730 |
| 3 | 114465 | CBD Spacious Luxury Suite with 30 sqm terrace | Chaoyang | 朝阳区 / Chaoyang | 100022 | Apartment | Entire home/apt | 2 | 1.0 | 1.0 | 1.0 | {TV,"Cable TV",Internet,Wifi,"Air conditioning",Kitchen,"Smoking allowed",Doorman,Elevator,Heating,"Family/kid friendly",Washer,"Smoke alarm","Carbon monoxide alarm","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer","Laptop-friendly workspace","Hot water","Bed linens","Ethernet connection","Shower gel"} | NaN | 602.0 | 4760.0 | NaN | NaN | 30.0 | 1 | 0.0 | 1 | 1125 |
| 4 | 128496 | Heart of Beijing: House with View 2 | Dong Si | 东城区 | NaN | House | Entire home/apt | 3 | 1.0 | 1.0 | 2.0 | {TV,Internet,Wifi,"Air conditioning",Doorman,Breakfast,Heating,"Family/kid friendly",Washer,Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Private entrance","Hot water","Bed linens","Extra pillows and blankets",Microwave,Refrigerator,"Dishes and silverware","Single level home","Patio or balcony","Garden or backyard","Luggage dropoff allowed","Long term stays allowed"} | 323.0 | 411.0 | 3185.0 | NaN | 0.0 | 71.0 | 2 | 106.0 | 3 | 365 |
| 5 | 161902 | cozy studio in center of Beijing | Dongcheng | 东城区 | 100027 | Apartment | Entire home/apt | 2 | 1.0 | 1.0 | 1.0 | {TV,"Cable TV",Internet,Wifi,"Air conditioning","Wheelchair accessible",Kitchen,"Pets allowed",Doorman,Elevator,Heating,"Family/kid friendly",Washer,Dryer,Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop-friendly workspace"} | NaN | 552.0 | 490.0 | 1600.0 | 0.0 | 0.0 | 1 | 0.0 | 1 | 365 |
| 6 | 162144 | nice studio near subway, sleep 4 | Dongcheng | 朝阳区 / Chaoyang | 100027 | Apartment | Entire home/apt | 4 | 1.0 | 1.0 | 2.0 | {TV,"Cable TV",Internet,Wifi,"Air conditioning","Wheelchair accessible",Kitchen,"Smoking allowed","Pets allowed",Doorman,Gym,Elevator,Heating,"Family/kid friendly",Washer,Dryer} | 0.0 | 601.0 | 560.0 | 1600.0 | 0.0 | 0.0 | 1 | 0.0 | 1 | 365 |
| 7 | 279078 | Nice Apartment in Beijing | Dongcheng | 东城区 | 100027 | Apartment | Entire home/apt | 2 | 1.0 | 1.0 | 1.0 | {TV,"Cable TV",Internet,Wifi,"Air conditioning","Wheelchair accessible",Kitchen,"Smoking allowed","Pets allowed",Doorman,Elevator,Heating,"Family/kid friendly",Washer,Dryer,Essentials,Shampoo} | NaN | 403.0 | 445.0 | 1750.0 | 700.0 | 0.0 | 2 | 64.0 | 1 | 365 |
| 8 | 282825 | Large 2 BR Apt in a great location | Sanlitun | 朝阳区 / Chaoyang | 100027 | Apartment | Entire home/apt | 4 | 2.0 | 2.0 | 3.0 | {TV,"Cable TV",Internet,Wifi,"Air conditioning",Kitchen,Doorman,Elevator,"Free street parking",Heating,"Family/kid friendly",Washer,Dryer,"Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer","Laptop-friendly workspace","Self check-in","Building staff","High chair","Hot water",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove} | NaN | 743.0 | 4884.0 | NaN | 0.0 | 283.0 | 2 | 0.0 | 3 | 90 |
| 9 | 287026 | Studio in downtown Beijing #2 | Dongcheng | 朝阳区 / Chaoyang | 100027 | Apartment | Entire home/apt | 3 | 1.0 | 1.0 | 1.0 | {TV,"Cable TV",Internet,Wifi,"Air conditioning","Wheelchair accessible",Kitchen,"Smoking allowed",Doorman,Elevator,Heating,Washer,Shampoo,Hangers,"Hair dryer",Iron,"Laptop-friendly workspace"} | NaN | 418.0 | 430.0 | 1500.0 | 1000.0 | 35.0 | 2 | 80.0 | 1 | 365 |
Last rows
| id | name | neighbourhood | neighbourhood_cleansed | zipcode | property_type | room_type | accommodates | bathrooms | bedrooms | beds | amenities | square_feet | price | weekly_price | monthly_price | security_deposit | cleaning_fee | guests_included | extra_people | minimum_nights | maximum_nights | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36273 | 43821919 | Danny’ s apartment | NaN | 通州区 / Tongzhou | NaN | Condominium | Entire home/apt | 2 | 1.0 | 1.0 | 1.0 | {TV,Wifi,"Air conditioning",Kitchen,Elevator,"Hot tub",Heating,Washer,"Smoke alarm",Essentials,Shampoo,Hangers,"Hair dryer","Laptop-friendly workspace","Hot water"} | NaN | 283.0 | NaN | NaN | NaN | NaN | 1 | 0.0 | 1 | 6 |
| 36274 | 43822638 | 中关村科学院东南小区带电梯南北通透户型 | Haidian | 海淀区 | NaN | Condominium | Entire home/apt | 2 | 1.0 | 2.0 | 2.0 | {TV,Wifi,"Air conditioning",Kitchen,"Pets allowed",Elevator,Heating,Washer,Hangers,"Hair dryer","Laptop-friendly workspace","Hot water"} | NaN | 283.0 | NaN | NaN | NaN | NaN | 1 | 0.0 | 30 | 365 |
| 36275 | 43823221 | 京韵邻里·记忆大床房站牛街小吃街旁近法源寺南锣鼓巷天坛后海康有为故居谭嗣同故居北京站南站西站 | Xicheng | 西城区 | NaN | Boutique hotel | Private room | 2 | 1.0 | 1.0 | 1.0 | {TV,Wifi,"Air conditioning",Heating,"Suitable for events","Smoke alarm","First aid kit","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door","Hair dryer","Laptop-friendly workspace"} | NaN | 983.0 | NaN | NaN | NaN | NaN | 1 | 0.0 | 1 | 1125 |
| 36276 | 43825036 | 【路客】初夏特惠|同仁医院| 崇文门地铁站|北京站·天安门·王府井|温馨·三室一厅一卫 | Dongcheng | 东城区 | NaN | House | Entire home/apt | 6 | 1.0 | 3.0 | 3.0 | {TV,Wifi,"Air conditioning",Kitchen,Elevator,Heating,Washer,"Smoke alarm","First aid kit","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer","Self check-in",Lockbox,"Hot water","Ethernet connection",Refrigerator,"Dishes and silverware","Cooking basics"} | NaN | 899.0 | NaN | NaN | 0.0 | 150.0 | 6 | 0.0 | 1 | 30 |
| 36277 | 43836478 | loft大床房 | Dongcheng | 东城区 | NaN | Boutique hotel | Private room | 2 | 1.0 | 1.0 | 2.0 | {TV,Wifi,"Air conditioning",Heating,"Suitable for events","Fire extinguisher",Shampoo,Hangers,"Hair dryer","Hot water"} | NaN | 396.0 | NaN | NaN | NaN | NaN | 1 | 0.0 | 1 | 1125 |
| 36278 | 43836486 | 墅境洋房身临其境 | NaN | 大兴区 / Daxing | NaN | Villa | Entire home/apt | 5 | 4.0 | 5.0 | 10.0 | {TV,Wifi,"Air conditioning",Kitchen,"Free parking on premises","Smoking allowed","Pets allowed",Gym,"Hot tub",Heating,"Suitable for events",Washer,"Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","Private entrance","Hot water"} | NaN | 1499.0 | NaN | NaN | NaN | NaN | 1 | 0.0 | 1 | 365 |
| 36279 | 43836628 | loft家庭房 | Dong Si | 东城区 | NaN | Boutique hotel | Private room | 4 | 1.0 | 1.0 | 2.0 | {TV,Wifi,"Air conditioning",Heating,"Suitable for events","Fire extinguisher",Shampoo,Hangers,"Hair dryer","Hot water"} | NaN | 503.0 | NaN | NaN | NaN | NaN | 1 | 0.0 | 1 | 1125 |
| 36280 | 43836721 | 豪华间大床房 | Dong Si | 东城区 | NaN | Boutique hotel | Private room | 2 | 1.0 | 1.0 | 1.0 | {TV,Wifi,"Air conditioning",Heating,"Suitable for events","Fire extinguisher",Shampoo,Hangers,"Hair dryer","Hot water"} | NaN | 701.0 | NaN | NaN | NaN | NaN | 1 | 0.0 | 1 | 1125 |
| 36281 | 43836771 | 落地窗大床房 | Dongcheng | 东城区 | NaN | Boutique hotel | Private room | 2 | 1.0 | 1.0 | 1.0 | {TV,Wifi,"Air conditioning",Heating,"Suitable for events","Fire extinguisher",Shampoo,Hangers,"Hair dryer","Hot water"} | NaN | 701.0 | NaN | NaN | NaN | NaN | 1 | 0.0 | 1 | 1125 |
| 36282 | 43836973 | 中关村新东方微软大厦总部北京大学人民大学新中关字节跳动西屋国际公寓月租短租 | Zhongguancun | 海淀区 | NaN | Hostel | Private room | 2 | 1.0 | 5.0 | 5.0 | {Wifi,"Air conditioning","Smoking allowed","Pets allowed",Elevator,Heating,Washer,"Smoke alarm","Fire extinguisher",Shampoo,Hangers,"Hair dryer","Laptop-friendly workspace","Hot water"} | NaN | 191.0 | NaN | NaN | NaN | NaN | 1 | 0.0 | 1 | 1125 |